﻿<TableSpec 
	xmlns="bb_appfx_table"
	xmlns:common="bb_appfx_commontypes" 
	ID="a5c8e394-8c9e-4cbe-b502-c47dddfeada5"
	Name="Pledge Payment Overflow"
	Description="When we overpay a pledge beyond all availabe installments, we create a new revenue split record to hold that overpayment.  This table maps those splits back to the original pledge id for bookeeping."
    Author="Blackbaud Professional Services"
	Tablename="USR_PLEDGEPAYMENTOVERFLOW"		   
	>

    <Fields>
        <!--For this to work prior to version 2.93, you would change these to REVENUESPLIT and REVENUE, respectively-->
        <ForeignKeyField Name="REVENUESPLITID" ForeignTable="FINANCIALTRANSACTIONLINEITEM"/>
        <ForeignKeyField Name="PLEDGEID" ForeignTable="FINANCIALTRANSACTION"/>
	</Fields>
</TableSpec>